package com.yulan.bankback.mapper.admin;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.yulan.bankback.entity.model.admin.EverydayVUCount;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

import java.util.List;

@Component
public interface EverydayVUCountMapper extends BaseMapper<EverydayVUCount> {

    @Select("select time, count from everyday_violation_user_count where " +
            "time > NOW() - INTERVAL ${interval}")
    List<EverydayVUCount> getDataInterval(@Param("interval") String interval);
}
